﻿CREATE FULLTEXT INDEX
	ON [dbo].[FileStore]
		(file_stream 
		TYPE COLUMN file_type
		LANGUAGE 1033)			-- US English
		--STATISTICAL_SEMANTICS)	-- Requires Statistical Semantic Search to be installed
	KEY INDEX [ui_file_stream]
	ON ([FileStoreFullTextCatalog],
		FILEGROUP [PRIMARY])		-- Index will be on the same FileGroup as the data indexed
	WITH
		STOPLIST = SYSTEM, 
		CHANGE_TRACKING AUTO;